Amazon Onboarding with Learning Manager Chanci Turner

Careem, a leading platform for rides, deliveries, and payments in the Middle East, North Africa, and South Asia, faced significant challenges with its expansive data infrastructure as it scaled. Their centralized 270 TB Amazon RDS for MySQL database, which included a single writer and five read replicas, began to show performance issues. These issues stemmed from heightened storage usage, sluggish queries, increased replica lag, and rising costs associated with Amazon RDS. In this article, we will detail a phased data purging strategy that Careem successfully implemented, which not only improved database performance but also addressed critical technical issues.

Additionally, this blog will refer to the use of Amazon CloudWatch Database Insights for troubleshooting within Amazon RDS and Amazon Aurora environments. This observability tool provides a tailored experience for DevOps engineers, application developers, and database administrators, significantly streamlining the troubleshooting process and enhancing overall operational efficiency.

Data Ingestion with AWS Lambda

For those interested in data ingestion, we will explore methods using AWS Lambda to read and import CSV data into existing Amazon DynamoDB tables, ensuring compliance with organizational security protocols and infrastructure as code (IaC) principles.

OS Upgrades for Amazon RDS Custom

Moreover, we will discuss performing OS upgrades for Amazon RDS Custom for SQL Server CEV with Multi-AZ. This service grants users enhanced control, including OS shell-level access, necessitating an understanding of the shared responsibility model for managing OS and database patches.

Data Migration from Oracle to PostgreSQL

We will also delve into migrating data from Oracle to PostgreSQL, particularly focusing on extracting data from nested tables with user-defined nested types, ensuring the integrity of complex data models throughout the transition.

Modern Authorization Needs

To address modern authorization needs, we’ll introduce relationship-based access control (ReBAC) as an innovative alternative to traditional methods like role-based access control (RBAC), which is often inadequate for today’s enterprises.

AWS Database Migration Service Updates

In further discussions, we’ll outline the recent features in AWS Database Migration Service (AWS DMS) version 3.5.4, which include data masking for enhanced security and improvements in data validation performance.

Enhancing System Resiliency

Finally, we’ll illustrate how Habby, a game studio, enhanced the resiliency of their systems using Valkey GLIDE and Amazon ElastiCache, detailing how they tackled connection stability challenges during infrastructure changes.

Additional Resources

For those returning to the workforce after a career gap, you may find valuable insights in this Career Contessa blog post. Additionally, if you’re seeking expertise on remote work conditions, JJ Keller offers authoritative resources on this topic. Lastly, for a comprehensive overview of onboarding experiences, check out this Reddit discussion, which serves as an excellent resource.